Download Oracle Business Intelligence Foundation Suite 11g Essentials.1z0-591.PracticeTest.2018-08-09.67q.vcex

Vendor: Oracle
Exam Code: 1z0-591
Exam Name: Oracle Business Intelligence Foundation Suite 11g Essentials
Date: Aug 09, 2018
File Size: 2 MB

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Purchase
Coupon: EXAM_HUB

Discount: 20%

Demo Questions

Question 1
WLS Embedded LDAP Server is managed by the Admin Server Console and supports which   three options?
  1. Creating and Maintaining Users
  2. Authentication and Authorization
  3. Basic Directory for storing user details
  4. Subject area and row-level security, connection pool passwords
  5. Application of Session Variables as Data Filters
Correct answer: ACD
Explanation:
WLS Embedded LDAP Server *By default, OBIEE 11g users and groups are now held in the WLS LDAP Server (C) - More robust directory for storing user details - Recommended for >1000 users *  WLS Admin Server Console now used for  creating and maintaining users (A) * BI Server “outsources” all authentication,  authorization to FMW11g (not B) * BI Administration tool now used for  subject area and row-level security, connection pool passwords only (D) • WLS LDAP Server can be “swapped out” for alternative directories (MS AD etc)
WLS Embedded LDAP Server 
*By default, OBIEE 11g users and groups are now held in the WLS LDAP Server (C) 
- More robust directory for storing user details 
- Recommended for >1000 users 
*  WLS Admin Server Console now used for  
creating and maintaining users (A) 
* BI Server “outsources” all authentication,  
authorization to FMW11g (not B) 
* BI Administration tool now used for  
subject area and row-level security, 
connection pool passwords only (D) 
• WLS LDAP Server can be “swapped out” 
for alternative directories (MS AD etc)
Question 2
Point-and-click generation of case statement logic can be accessed via which option?
  1. Column Formula -> Bins tab
  2. Compound Layout
  3. Column Properties -> Conditional Format tab
  4. Advanced Tab
  5. Subject Area metrics
Correct answer: A
Explanation:
The “Edit Column Formula” dialog box has a second, very tiny tab called, “Bins.”  You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under “Expressions” if you want).  A CASE statement is a lot like an IF-THEN-ELSE statement, except that it’s a little easier to read when you have multiple options.  Basically, it puts values in different buckets that you define. Note:Figure:    Incorrect answers:C: The “Conditional Format” tab lets you set formatting when specific conditions are met.
The “Edit Column Formula” dialog box has a second, very tiny tab called, “Bins.”  You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create a CASE statement yourself by using one of the functions that appears under “Expressions” if you want).  A CASE statement is a lot like an IF-THEN-ELSE statement, except that it’s a little easier to read when you have multiple options.  Basically, it puts values in different buckets that you define. 
Note:
Figure:
  
Incorrect answers:
C: The “Conditional Format” tab lets you set formatting when specific conditions are met.
Question 3
Which task can be performed after the Administrator link has been reached through logging into OBIEE?
  1. Associate map layers to columns
  2. Manage access to Subject Areas
  3. SSO enablement
  4. Start or Stop BI Managed Servers
Correct answer: BCD
Explanation:
B: BI Server Security Manager accessed through the BI Server Administration Tool.* Set permission to business model, tables, columns and subject areas * Specify filters to limit data accessible by users * Set authentication options C: Enable the SSO through the FMW Control.    D: You have three methods to start the managed server:with the console (recommended) with FMW control with the command line.
B: BI Server Security Manager accessed through the BI Server Administration Tool.
* Set permission to business model, tables, columns and subject areas 
* Specify filters to limit data accessible by users 
* Set authentication options 
C: Enable the SSO through the FMW Control.
  
D: You have three methods to start the managed server:
  • with the console (recommended) 
  • with FMW control 
  • with the command line.
Question 4
Which three techniques are applied to support Failover?
  1. WebLogic Clustering
  2. Universal Installer > Scale Out BI System option
  3. OBIEE Clustering
  4. Vertical Scaleout
Correct answer: ABC
Explanation:
A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, you’d choose to instead scale out the existing BI domain.    C: OBIEE Clustering – Approach of Oracle BI Server Load balancing/Failover
A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.
B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, you’d choose to instead scale out the existing BI domain.
  
C: OBIEE Clustering – Approach of Oracle BI Server Load balancing/Failover
Question 5
The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS applications?
  1. MS Visio
  2. MS Excel
  3. MS Project
  4. MS Word
Correct answer: BD
Explanation:
Oracle Business Intelligence Office Plug-In is a Windows application that is an optional feature under the Oracle Business Intelligence Presentation Services. The Plug-In provides a way to browse the Analytics catalog, select a report, and then drop that report into Microsoft Word or Excel. Reference: Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Installing Individual Oracle BI Components >Installing Oracle BI Office Plug-In
Oracle Business Intelligence Office Plug-In is a Windows application that is an optional feature under the Oracle Business Intelligence Presentation Services. The Plug-In provides a way to browse the Analytics catalog, select a report, and then drop that report into Microsoft Word or Excel. 
Reference: Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Installing Individual Oracle BI Components >Installing Oracle BI Office Plug-In
Question 6
A user's BI Home page provides one-click access to which three options?
  1. Create new content
  2. Oracle BI online documentation
  3. Catalog search functionality
  4. Dashboard layout editor
  5. Business model metadata
Correct answer: ABC
Explanation:
See  BI Home Page screenshot below:    Note: The BI Home page contains the BI content catalog. Fusion Apps will use OBIEE web catalog to store all shipped reporting and analytics content.From the BI home page users can browse and view the entire BI content. The BI catalog folder structure will match the Fusion Apps main menu structure. Folder structure would be content driven not technology driven which would enable ease of navigation for fusion Apps users. Following content will be available under the BI catalog structure:BI Publisher Reports (regardless of data source) OTBI reports & dashboards OBIA dashboards & scorecards Financial Reporting Also, users can do some additional actions from the BI Home page like: Access personal and shared reports, View/ edit BI publisher report schedules, Launch BI tools for advanced actions and create new reports with report wizard.New reports created can be saved in BI catalog and added as embedded content within Fusion applications screens or links added to reporting pane. This enables users to extend the prebuilt embedded analytics within Fusion Applications.
See  BI Home Page screenshot below:
  
Note: The BI Home page contains the BI content catalog. Fusion Apps will use OBIEE web catalog to store all shipped reporting and analytics content.
From the BI home page users can browse and view the entire BI content. The BI catalog folder structure will match the Fusion Apps main menu structure. Folder structure would be content driven not technology driven which would enable ease of navigation for fusion Apps users. 
Following content will be available under the BI catalog structure:
BI Publisher Reports (regardless of data source) 
OTBI reports & dashboards 
OBIA dashboards & scorecards 
Financial Reporting 
Also, users can do some additional actions from the BI Home page like: Access personal and shared reports, View/ edit BI publisher report schedules, Launch BI tools for advanced actions and create new reports with report wizard.
New reports created can be saved in BI catalog and added as embedded content within Fusion applications screens or links added to reporting pane. This enables users to extend the prebuilt embedded analytics within Fusion Applications.
Question 7
A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?
  1. By creating a derived measure by using the Logical Columns available
  2. By creating a derived measure in the Column Mapping dialog box by using the physical table columns.
  3. By creating a derived measure by using Logic Columns available and changing the aggregation type
  4. By creating a derived metric by using the Expression Builder
  5. By creating a derived metric by using the Calculation Wizard
Correct answer: B
Explanation:
Note 1: OBIEE offers two calculation types for measure in the repository:logical physical You can define calculations in either of the following ways:Before the aggregation, in the logical table source. After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)Note 2: A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.Measure columns always calculate the aggregation with which they are defined. Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.    
Note 1: OBIEE offers two calculation types for measure in the repository:
logical 
physical 
You can define calculations in either of the following ways:
  • Before the aggregation, in the logical table source. 
  • After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)
Note 2: A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.
Measure columns always calculate the aggregation with which they are defined. 
Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure. 
  
Question 8
Which resource identifies the OBIEE Web Catalog (webcat)?
  1. instanceconfig.xml
  2. RCU Schema
  3. Identity Store
  4. nqsconfig.ini
  5. Admin Server
Correct answer: CE
Explanation:
C: Oracle Business Intelligence authenticates users and get groups using an Oracle WebLogic Server authentication provider against user information held in an identity store.Incorrect answers:A: On 10g, Instanceconfig.xml is THE parameter file of the BI Presentation server. With the advent of 11g, instanceconfig.xml is also the configuration file of Oracle BI SchedulerThe instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation Services. B: If you want to install the OBIEE Server you have to create some schemas in the database which will keep the OBIEE repository. For working, OBIEE needs some schemas to be created. This work is dome automatically by using rcu  (Repository Creation Utility).   In order to create the OBIEE schemas with the RCU, you must have installed an Oracle database (11g). D: NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.The file is located in this directory :11g: ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisnAll changes made to this file require that you restart the Oracle BI Server Service. Note: OBIEE 10G/11G - The (Web|Presentation) Catalog (Webcat)The Web Catalog becomes in 11g the Presentation Catalog. publisher objects (such as reports and templates). Each object is composed of two files:* its own file. For example, an analysis called Analysis 1 would be stored in a file named Analysis1. * a attributes file. For example, the analysis called Analysis1 would have a corresponding attributes file named Analysis1.atr. The attributes file contains:the object's full name, access control list (ACL), description, and so on. To access an object in the catalog, users must have appropriate ACL entries for that object. All objects in the catalog use ACL entries. In 11g, the Everyone group has been replaced with the AuthenticatedUser role The webcatalog is located:on 11G: ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/catalog/
C: Oracle Business Intelligence authenticates users and get groups using an Oracle WebLogic Server authentication provider against user information held in an identity store.
Incorrect answers:
A: On 10g, Instanceconfig.xml is THE parameter file of the BI Presentation server. With the advent of 11g, instanceconfig.xml is also the configuration file of Oracle BI Scheduler
The instanceconfig.xml file stores the configuration settings that affect Oracle BI Presentation Services. 
B: If you want to install the OBIEE Server you have to create some schemas in the database which will keep the OBIEE repository. For working, OBIEE needs some schemas to be created. This work is dome automatically by using rcu  (Repository Creation Utility).
   In order to create the OBIEE schemas with the RCU, you must have installed an Oracle database (11g). 
D: NQSConfig.ini is the main configuration file of Bi Server and contains a lot of parameters.
The file is located in this directory :
11g: ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn
All changes made to this file require that you restart the Oracle BI Server Service. 
Note: OBIEE 10G/11G - The (Web|Presentation) Catalog (Webcat)
The Web Catalog becomes in 11g the Presentation Catalog. 
publisher objects (such as reports and templates). 
Each object is composed of two files:
* its own file. For example, an analysis called Analysis 1 would be stored in a file named Analysis1. 
* a attributes file. For example, the analysis called Analysis1 would have a corresponding attributes file named Analysis1.atr. 
The attributes file contains:
the object's full name, 
access control list (ACL), 
description, 
and so on. 
To access an object in the catalog, users must have appropriate ACL entries for that object. All objects in the catalog use ACL entries. 
In 11g, the Everyone group has been replaced with the AuthenticatedUser role 
The webcatalog is located:
on 11G: ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/catalog/
Question 9
The ODBC DSN is never used for _______.
  1. Initial import of the physical layer metadata on a Windows server
  2. Query execution and data access on a Windows server
  3. Initial import of the physical layer metadata, query execution, and data access on a Windows Server
  4. Changing passwords
  5. Comparing RPDs
Correct answer: E
Explanation:
You do not use ODBC DSN to compare repositories. Note: When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect.Some external repository of configuration information holds the various DSN values that are available, together with the necessary configuration and control information needed by the ODBC driver to establish a connection and manage usage of the data source. The DSN (data source name) is a data structure that contains the information about a specific data source (database, …), typically used by an ODBC driver to be able to connect to it. The DSN contains information about the data source such as:the name, the directory, and the driver. On Windows, the DSN also specifies the ODBC driver to be used to access the database.
You do not use ODBC DSN to compare repositories. 
Note: When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect.
Some external repository of configuration information holds the various DSN values that are available, together with the necessary configuration and control information needed by the ODBC driver to establish a connection and manage usage of the data source. 
The DSN (data source name) is a data structure that contains the information about a specific data source (database, …), typically used by an ODBC driver to be able to connect to it. 
The DSN contains information about the data source such as:
the name, 
the directory, 
and the driver. 
On Windows, the DSN also specifies the ODBC driver to be used to access the database.
Question 10
Identify the reason why Oracle OLAP provides a favorable aggregation strategy.
  1. OLAP cubes eliminate the need for a large number of aggregate tables.
  2. OLAP cubes are stored outside of the database in highly optimized file structures.
  3. OLAP cubes can be easily transported from database to database.
  4. OLAP cubes can be queried by using SQL.
Correct answer: D
Explanation:
All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL. Reference: Oracle OLAP User's Guide, What's New in Oracle OLAP?
All metadata for cubes and dimensions is stored in the Oracle database and revealed in the data dictionary views, so that you can query the entire business model in SQL. 
Reference: Oracle OLAP User's Guide, What's New in Oracle OLAP?
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!